﻿using System;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Migrations;

namespace Magicodes.Admin.Migrations
{
    public partial class Add_MonthlyListings : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "MonthlyListings",
                columns: table => new
                {
                    Id = table.Column<long>(nullable: false)
                        .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
                    CreatorUserId = table.Column<long>(nullable: true),
                    CreationTime = table.Column<DateTime>(nullable: false),
                    LastModifierUserId = table.Column<long>(nullable: true),
                    LastModificationTime = table.Column<DateTime>(nullable: true),
                    DeleterUserId = table.Column<long>(nullable: true),
                    DeletionTime = table.Column<DateTime>(nullable: true),
                    IsDeleted = table.Column<bool>(nullable: false),
                    TenantId = table.Column<int>(nullable: true),
                    Sequencenumber = table.Column<string>(nullable: true),
                    Date = table.Column<string>(nullable: true),
                    WaybillNumber = table.Column<string>(nullable: true),
                    AreaOfTheOtherParty = table.Column<string>(nullable: true),
                    CompanyNameOfTheOtherParty = table.Column<string>(nullable: true),
                    BillingWeight = table.Column<string>(nullable: true),
                    ProductType = table.Column<string>(nullable: true),
                    PaymentMethod = table.Column<string>(nullable: true),
                    Fee = table.Column<string>(nullable: true),
                    DiscountOrPromotion = table.Column<string>(nullable: true),
                    AmountPayable = table.Column<string>(nullable: true),
                    Agent = table.Column<string>(nullable: true),
                    ValueAddedFee = table.Column<string>(nullable: true),
                    PlaceOfOrigin = table.Column<string>(nullable: true),
                    MailingCompanyName = table.Column<string>(nullable: true),
                    MailingCompanyTelephone = table.Column<string>(nullable: true),
                    ArrivingArea = table.Column<string>(nullable: true),
                    ArrivingCustomerName = table.Column<string>(nullable: true),
                    ArrivingCustomerTelephone = table.Column<string>(nullable: true),
                    Sender = table.Column<string>(nullable: true),
                    MailingTime = table.Column<string>(nullable: true),
                    OriginatingPlaceProvincialName = table.Column<string>(nullable: true),
                    MailingCompanyAddress = table.Column<string>(nullable: true),
                    ReceiptManualNumber = table.Column<string>(nullable: true),
                    ConsignmentContent = table.Column<string>(nullable: true),
                    ConsignmentQuantity = table.Column<string>(nullable: true),
                    DeclaredValue = table.Column<string>(nullable: true),
                    NumberOfPieces = table.Column<string>(nullable: true),
                    Volume = table.Column<string>(nullable: true),
                    DestinationProvinceName = table.Column<string>(nullable: true),
                    Recipient = table.Column<string>(nullable: true),
                    ReceivingAddress = table.Column<string>(nullable: true),
                    DispatchEmployeeNumber = table.Column<string>(nullable: true),
                    ActualWeight = table.Column<string>(nullable: true),
                    ReturnBillNumber = table.Column<string>(nullable: true),
                    SignatoryAndRecipient = table.Column<string>(nullable: true),
                    TimeOfSigningAndReceiving = table.Column<string>(nullable: true),
                    ReturnRelatedTransportBillNumber = table.Column<string>(nullable: true),
                    AdditionalField1 = table.Column<string>(nullable: true),
                    AdditionalField2 = table.Column<string>(nullable: true),
                    AdditionalField3 = table.Column<string>(nullable: true),
                    SettlementDate = table.Column<string>(nullable: true),
                    PaymentNetwork = table.Column<string>(nullable: true),
                    SubsidiaryCardNumber = table.Column<string>(nullable: true),
                    Notes = table.Column<string>(nullable: true),
                    ExpressContent = table.Column<string>(nullable: true),
                    Country = table.Column<string>(nullable: true),
                    RegionType = table.Column<string>(nullable: true),
                    ReservedFields5 = table.Column<string>(nullable: true),
                    Long = table.Column<string>(nullable: true),
                    Wide = table.Column<string>(nullable: true),
                    High = table.Column<string>(nullable: true),
                    SendCityCode = table.Column<string>(nullable: true),
                    ReceiveCityCode = table.Column<string>(nullable: true),
                    SendDeptCode = table.Column<string>(nullable: true),
                    DeliveryDeptCode = table.Column<string>(nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_MonthlyListings", x => x.Id);
                });
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "MonthlyListings");
        }
    }
}
